Re: NULL fields in inner join

At 15:57 -0200 2003/01/15, Fernando Braga wrote:
>Hi Guys,
>
>If i run an INNER JOIN through odbc, all NULL fields are retrieved with
>values (??!). And worse of that, when this occurs, the lines with NULL
>fields comes three times.
>
>Of course, when I do the SQL on the linux server, it comes correct
>
>Have anybody experienced this behaviour ?
>
>I've attached linux_server.txt and xp_client.jpg
>

sorry, but first you are doing an outer join, second the two queries
seem to have the same results except for the ordering (as the order
by is not the same).
So, what's wrong?

g